package com.itheima.ssm.dao;

import com.itheima.ssm.domain.Traveller;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Description:heima_ssm
 * Created by admin  on 2020/3/3  12:59
 *
 * 游客Dao
 */
public interface ITravellerDao {

    @Select("select * from traveller where id in (select travellerId from order_traveller where orderId=#{ordersId}) ")
    public List<Traveller> findByOrdersId(Integer ordersId) throws Exception;
}
